Loading…
Wednesday, October 31 • 8:00am - 12:00pm
Academy Course - Power BI: Enhance Your Data Model with DAX ($499)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Register to attend this class or follow the instructions below to include registration for the Power BI World Tour.

Please Note:  Academy workshops are half-day, full-day, or two-day training sessions that will build your skills through hands-on, deep dive education. Our Academy Courses do require a separate registration. If you are registering for the Power BI World Tour, you will have the option to add on Academy classes during the registration process.

If you have already registered, it's not to late to add on a class!!
  • To edit your registration,  please click here and follow these steps:
    •  This will bring you to the Registration page – you will see a message stating "You are currently Registered." Click on Edit Registration (right side of screen).
    • When you see your registration, click Edit.
    • On the next screen, click Add Activities.
    • Check the box next to the class title you're interested in.
    • Follow the prompts to complete the process of adding this class to your registration.

Academy Course: Power BI: Enhance Your Data Model with DAX

Why do you need the course?
To take your data model beyond simple aggregations and create more complex calculations that span multiple tables and millions of rows of data.

Course Objectives:
By the end of this course, you will be able to use DAX to create calculations in a Power BI Desktop data model. Specifically, you will be able to:
  • Understand the concepts of Data Modeling
  • Understand the consequences of data model design decisions
  • Understand concepts of calculated columns and measures
  • Gain familiarity with standard DAX patterns & CALCULATE
  • Understand evaluation contexts and their impact on calculations
  • Gain ability to parse data modeling formulas
This class is a combination of Lecture, Demo and Lab

The class is designed for someone with intermediate-level Power BI experience.

Please bring a laptop to the course, with the following connectivity and software installed:

Internet connectivity: You must be connected to the internet
  • At minimum, a computer with 2-cores and 4GB RAM running one of the following version of Windows: Windows 7, indows 8, (64-bit preferred), Windows 8.1 or Windows 10 or Windows Server 2008 R2 or Windows Server 2012/R2 
  • Microsoft Power BI Desktop requires Internet Explorer 9 or greater
  • Verify if you have 32bit or 64bit operating system to decide if you need to install the 32bit or 64bit applications. 
  • Search for computer on your PC, right click properties for your computer
  • You will be able to identify if your operating system is 64 or 32 bit based on “system type” as shown below
  • Download and install Power BI Desktop: Download and install Microsoft Power BI Desktop from http://www.microsoft.com/en-us/download/details.aspx?id=45331. Please choose appropriate 64-bit or 32-bit version depending on your platform. Microsoft Power BI Desktop is available for 32-bit (x86) and 64-bit (x64) platforms
Download Class Files:
Copy Files from your USB to C:\Power BI_Adv_Model\ (Please return the USBs)




Speakers
avatar for Brian Grant

Brian Grant

Analytics Consultant, CSG Pro


Wednesday October 31, 2018 8:00am - 12:00pm PDT
Microsoft ADVANTA Building B 3009 160th Ave SE Bellevue, WA 98008

Attendees (5)